home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / orinf / oct96 / lopaf103.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  64.6 KB  |  339x530  |  4-bit (16 colors)
   ocr: The following statemcnt creares a cable and provides STORAGE parameter valucs: CREATE TABLE dept (deptno NUMBER(2), dnane VARUHAR2(14), loc VARCHAR2(13) ) STORAGE (INITIAL 100K NEXT50K MINEXTENTS 1 MAXEAIENTS 50 PUTINCREASE 5 ) Oracic7 allocates space for the table based on the STORAGE parameter values for the following casons: Because the MINEXTENTS valuc is 1, Oracle7 allocates 1 extent for the cablc upon creation. Because the INIIAL value, is. 100KB, the first extents SIZC is 100KB. Ifthe table data grows to excccd the first extent, Oracle7 allocatcs a second cxtent. Because the NEXT value ...